Postgresql Mcp

Created By

Prasanna H13 days ago

## Overview This is an MCP (Model Context Protocol) server that provides intelligent analysis, documentation, and complete CRUD operations for PostgreSQL databases. It combines deterministic schema extraction with AI-powered reasoning and secure data manipulation operations to help users and AI agents understand and interact with complex database structures. **Performance Optimized & Extended:** Started at 38 tools, optimized to 19 tools (~50% reduction), then strategically extended to 27 tools with high-value query optimization, data management, transactions, and monitoring capabilities. ### Key Features - **Comprehensive Coverage**: 27 carefully designed tools covering all PostgreSQL operations - **Schema Extraction**: Automatically extract tables, columns, relationships, and constraints - **Intelligent Analysis**: Detect junction tables, implicit relationships, and suggest optimal joins - **AI-Powered Insights**: Leverage Ollama/LLM to generate business explanations and recommendations - **Complete CRUD Operations**: Unified tools for all data manipulation with SQL injection prevention - **Query Optimization**: Execution plan analysis, combined index analysis (suggest + unused detection) - **Data Management**: Import/export (CSV/JSON/SQL), full-text search - **Transaction Support**: Atomic multi-operation transactions with rollback - **Monitoring**: Database statistics, cache metrics, slow queries, connection tracking - **Multiple Output Formats**: - Mermaid ER diagrams (with SVG rendering) - Mermaid relationship flowcharts (with SVG rendering) - Comprehensive Markdown documentation - Visual diagram files (SVG, PNG, PDF) - **Query Assistance**: Smart join type recommendations (INNER vs LEFT) - **Modular Architecture**: Clean, extensible design organized by capability - **Diagram Rendering**: Auto-generate visual database structure diagrams - **Security**: Parameterized queries, input validation, SQL injection prevention

# database

Overview Content Tools Comments

Overview

This is an MCP (Model Context Protocol) server that provides intelligent analysis, documentation, and complete CRUD operations for PostgreSQL databases. It combines deterministic schema extraction with AI-powered reasoning and secure data manipulation operations to help users and AI agents understand and interact with complex database structures.

Performance Optimized & Extended: Started at 38 tools, optimized to 19 tools (~50% reduction), then strategically extended to 27 tools with high-value query optimization, data management, transactions, and monitoring capabilities.

Key Features

Comprehensive Coverage: 27 carefully designed tools covering all PostgreSQL operations
Schema Extraction: Automatically extract tables, columns, relationships, and constraints
Intelligent Analysis: Detect junction tables, implicit relationships, and suggest optimal joins
AI-Powered Insights: Leverage Ollama/LLM to generate business explanations and recommendations
Complete CRUD Operations: Unified tools for all data manipulation with SQL injection prevention
Query Optimization: Execution plan analysis, combined index analysis (suggest + unused detection)
Data Management: Import/export (CSV/JSON/SQL), full-text search
Transaction Support: Atomic multi-operation transactions with rollback
Monitoring: Database statistics, cache metrics, slow queries, connection tracking
Multiple Output Formats:
- Mermaid ER diagrams (with SVG rendering)
- Mermaid relationship flowcharts (with SVG rendering)
- Comprehensive Markdown documentation
- Visual diagram files (SVG, PNG, PDF)
Query Assistance: Smart join type recommendations (INNER vs LEFT)
Modular Architecture: Clean, extensible design organized by capability
Diagram Rendering: Auto-generate visual database structure diagrams
Security: Parameterized queries, input validation, SQL injection prevention

Server Config

{
  "mcpServers": {
    "SchemaIntelligence": {
      "command": "C:\\Users\\user\\.local\\bin\\uv.EXE",
      "args": [
        "run",
        "--frozen",
        "--with",
        "mcp[cli]",
        "--with",
        "psycopg2",
        "--with",
        "ollama",
        "--with",
        "pymermaid",
        "--with",
        "requests",
        "--with",
        "pillow",
        "mcp",
        "run",
        "C:\\Users\\user\\Desktop\\MCP-ToolHub\\PostgreSQL-MCP\\postgresql_server.py"
      ],
      "env": {
        "DB_HOST": "localhost",
        "DB_PORT": "6739",
        "DB_NAME": "MCP",
        "DB_USER": "postgres",
        "DB_PASSWORD": "radha",
        "OLLAMA_BASE_URL": "http://192.168.1.143:11434",
        "OLLAMA_MODEL": "gpt-oss:120b-cloud",
        "DEBUG": "False"
      }
    }
  }
}

Recommend Servers

TraeBuild with Free GPT-4.1 & Claude 3.7. Fully MCP-Ready.

DeepChatYour AI Partner on Desktop

Serper MCP ServerA Serper MCP Server

Jina AI MCP ToolsA Model Context Protocol (MCP) server that integrates with Jina AI Search Foundation APIs.

MCP AdvisorMCP Advisor & Installation - Use the right MCP server for your needs

Baidu Map百度地图核心API现已全面兼容MCP协议，是国内首家兼容MCP协议的地图服务商。

CursorThe AI Code Editor

AiimagemultistyleA Model Context Protocol (MCP) server for image generation and manipulation using fal.ai's Stable Diffusion model.

Y GuiA web-based graphical interface for AI chat interactions with support for multiple AI models and MCP (Model Context Protocol) servers.

WindsurfThe new purpose-built IDE to harness magic

Visual Studio Code - Open Source ("Code - OSS")Visual Studio Code